{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Customer","Dropdowns","CredControlArea","Credit Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Customer","index":0,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"CREDIT SEGMENT",null,null,"Version 1.0"]
[]
[]
[]
[]
[]
[null,"Business Partner Code","*",1234567]
[null,"Please Select","*",1100,null,{"$f":"IF(D10<>\"\",VLOOKUP(D10,Dropdowns!$A$2:$B$7,2,FALSE),\"\")","v":"Darley Butler & Co. Ltd"}]
[]
[]
[]
[null,"Limit","*",13124324454]
[null,"Credit Segment","*","1101 Hard Ware"]
[]
[]
[null,"Risk Class",null,"B Low Default Risk"]
[null,"Check Rule",null,"02 Credit Limit Check Only (Statistical)"]

{"sheet":"Dropdowns","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Company Code","Company Name"]
[1000,"E.B.Creasy  & Co.PLC"]
[1100,"Darley Butler & Co. Ltd"]
[1300,"Candy Delights Limited"]
[1400,"Laxapana Batteries PLC"]
[1500,"Muller& Phipps Ceylon PLC"]
[1550,"Pettah Pharmacy (Pvt) Ltd"]

{"sheet":"CredControlArea","index":2,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Credit Control Area"]
["E.B.Creasy  & Co.PLC","1000 EB Creasy & Co PLC"]
["Darley Butler & Co. Ltd","1100 Darley Butler & Co Ltd"]
["Darley Butler & Co. Ltd","1101 Hard Ware"]
["Darley Butler & Co. Ltd","1102 Pharmaceutical"]
["Darley Butler & Co. Ltd","1103 Consumer"]
["Darley Butler & Co. Ltd","1104 Special Bakery"]
["E.B Creasy Logistics Ltd","1200 E.B Creasy Logistics Ltd."]
["Candy Delights Limited","1300 Creasy Foods Ltd"]
["Laxapana Batteries PLC","1400 Laxapana Batteries PLC"]
["Muller& Phipps Ceylon PLC","1500 Muller & Phipps Ceylon PLC"]
["Pettah Pharmacy (Pvt) Ltd","1550 Pettah Pharmacy (Pvt) Ltd"]

{"sheet":"Credit Data","index":3,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["A No Default Risk"]
["B Low Default Risk"]
["C Medium Default Risk"]
["D High Default Risk"]
["E Very High Default Risk"]
[]
[]
["01 Default - All Checks Active (Stat. Credit Limit)"]
["02 Credit Limit Check Only (Statistical)"]
["03 Credit Limit Check Only (Dynamic)"]